Gen Report Date: 2023-07-25

Years: 2021, 2022, 2023

Channels: MNG, WTC

Measures: Product Revenue($), Product Qty(#)

1 ) Product Revenue KPI

2 ) Channel

2.1 Product Revenue Trend

2.2 Product Revenue Portfolio

2.3 Product Revenue Portfolio Distribution

3 ) Brand

3.1 Product Revenue Trend

3.1.1 Total: MNG + WTC

3.1.2 MNG

3.1.3 WTC

3.2 Product Revenue Portfolio

3.2.1 Total: MNG + WTC

3.2.2 MNG

3.2.3 WTC

3.3 Product Revenue Portfolio Distribution

3.3.1 Total: MNG + WTC

3.3.2 MNG

3.3.3 WTC

3.4 Product Revenue and Qty

4 ) Product

4.1 Product Revenue Portfolio Distribution

4.2 Top 80% Revenue

4.2.1 Total: MNG + WTC

4.2.2 MNG

4.2.3 WTC

4.3 Product Revenue and Qty

4.4 Product Revenue Trend

4.4.1 Total: MNG + WTC

4.4.2 MNG

4.4.3 WTC

4.5 Correlation Product Revenue

5 ) Appendix

Data Summary Description

Data : Scan Sales Report (MNG and WTC)

Dimensions: 3300 x 19
Duplicates: 0
No Variable Stats / Values Freqs (% of Valid) Graph Missing
1 CHANNEL [character]
1. MNG
2. WTC
1260(38.2%)
2040(61.8%)
0 (0.0%)
2 ITEMID [character]
1. DCATA040BTHK02
2. DLBSC120BXHK01
3. DLJSC120BXHK01
4. FDC02014
5. FDC07016
6. FDC45016
7. FGB016
8. FHP013
9. FHP013TWFJT01C
10. FIS014
[ 72 others ]
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
2700(81.8%)
0 (0.0%)
3 DATE [Date]
min : 2021-01-01
med : 2022-03-16
max : 2023-06-01
range : 2y 5m 0d
30 distinct values 0 (0.0%)
4 PROD_REV [numeric]
Mean (sd) : 198451.4 (479589.9)
min ≤ med ≤ max:
-199 ≤ 7883 ≤ 5500000
IQR (CV) : 176108.3 (2.4)
1472 distinct values 0 (0.0%)
5 PROD_QTY [numeric]
Mean (sd) : 846.4 (5282.6)
min ≤ med ≤ max:
-1 ≤ 0 ≤ 130148
IQR (CV) : 457 (6.2)
1057 distinct values 0 (0.0%)
6 DATAAREAID [character] 1. vghp
3300(100.0%)
0 (0.0%)
7 ITEMNAME_ENG [character]
1. Extra Strength Uricsil 60
2. Extra Strength Vita Joint
3. Extra Strength Vita Yin Y
4. Extra Strength Vita Yin Y
5. Fortified I See 40's
6. G.E. Yunzhi Essence 60's
7. Glucobest 60's
8. Herba Precious 30's
9. Herba Precious 30's Twin
10. Lingzhi 72's (NB) Twin Pa
[ 72 others ]
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
2700(81.8%)
0 (0.0%)
8 ITEMNAME_CHI [character]
1. Extra Strength Uricsil 60
2. Lingzhi 72's (New Box) Tw
3. Lingzhi K-Cap 72's (NB) T
4. Vita Hair 90's Twin Pack
5. 活關素特強特效60粒
6. 維特健靈 加強配方 知音蟲草 60粒 (Alu)
7. 維特健靈 加強配方 知音蟲草孖裝+加強配方 知音蟲
8. 維特健靈 寧心 60粒
9. 維特健靈 小兒靈芝蜜 250毫升
10. 維特健靈 強效目清素 40粒
[ 72 others ]
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
60(1.8%)
2700(81.8%)
0 (0.0%)
9 PRODUCTTYPE [character] 1. 1
3300(100.0%)
0 (0.0%)
10 ITEMGROUPID [character]
1. DC
2. LZ
3. VH
4. YY
5. DCJ
6. HP
7. IS
8. JT
9. YZ
10. GB
[ 20 others ]
990(30.0%)
330(10.0%)
270(8.2%)
180(5.5%)
150(4.5%)
120(3.6%)
120(3.6%)
120(3.6%)
120(3.6%)
60(1.8%)
840(25.5%)
0 (0.0%)
11 Company [character] 1. VGHP
3300(100.0%)
0 (0.0%)
12 Brand [factor]
1. VG
2. VH
3. DC
4. NV
5. WATON
1560(47.3%)
330(10.0%)
1230(37.3%)
120(3.6%)
60(1.8%)
0 (0.0%)
13 SubBrand [character]
1. Functions
2. JointsAndBones
3. LZ
4. Vitamins
5. VH
6. YY
7. HP
8. IS
9. YZ
10. VC
[ 16 others ]
480(15.1%)
420(13.2%)
390(12.3%)
330(10.4%)
210(6.6%)
180(5.7%)
120(3.8%)
120(3.8%)
120(3.8%)
90(2.8%)
720(22.6%)
120 (3.6%)
14 ProductCategoryName [character]
1. Capsule
2. Chewable
3. Foot Patch
4. Honey
5. Sachet
6. Shampoo
7. Softgel
8. Spray
9. Tablet
10. Tonic
1620(55.7%)
30(1.0%)
60(2.1%)
60(2.1%)
150(5.2%)
30(1.0%)
330(11.3%)
30(1.0%)
570(19.6%)
30(1.0%)
390 (11.8%)
15 ProductSubCategoryName [character] 1. Finished Goods
2880(100.0%)
420 (12.7%)
16 ProductSubCategoryID [character]
1. VG_DC_JNB_SOF_FG
2. VG_DC_VTM_TAB_FG
3. VG_VG_LZ_CAP_FG
4. VG_DC_FTN_TAB_FG
5. VG_VG_YY_CAP_FG
6. VG_DC_FTN_CAP_FG
7. VG_VH_VH_CAP_FG
8. VG_DC_JNB_TAB_FG
9. VG_VG_HP_CAP_FG
10. VG_VG_IS_CAP_FG
[ 31 others ]
240(7.3%)
240(7.3%)
210(6.4%)
180(5.5%)
180(5.5%)
150(4.5%)
150(4.5%)
120(3.6%)
120(3.6%)
120(3.6%)
1590(48.2%)
0 (0.0%)
17 YEAR [integer]
Mean (sd) : 2021.8 (0.7)
min ≤ med ≤ max:
2021 ≤ 2022 ≤ 2023
IQR (CV) : 1 (0)
2021:1320(40.0%)
2022:1320(40.0%)
2023:660(20.0%)
0 (0.0%)
18 MONTH [integer]
Mean (sd) : 5.9 (3.4)
min ≤ med ≤ max:
1 ≤ 5.5 ≤ 12
IQR (CV) : 6 (0.6)
12 distinct values 0 (0.0%)
19 MONTH_ABBR [character]
1. Apr
2. Feb
3. Jan
4. Jun
5. Mar
6. May
7. Aug
8. Dec
9. Jul
10. Nov
[ 2 others ]
330(10.0%)
330(10.0%)
330(10.0%)
330(10.0%)
330(10.0%)
330(10.0%)
220(6.7%)
220(6.7%)
220(6.7%)
220(6.7%)
440(13.3%)
0 (0.0%)